<?php

include_once "core/settings.php";
include_once "{$_GLOBAL['reunionhome']}/lib/ez_sql_core.php";
include_once "{$_GLOBAL['reunionhome']}/lib/ez_sql_mysql.php";


$db = new ezSQL_mysql($_GLOBAL['dbuser'], $_GLOBAL['dbpass'], $_GLOBAL['dbname'], $_GLOBAL['dbhost']);

// reunion_ParticipantWeeks
$sql = "
	DROP TABLE IF EXISTS `reunion_ParticipantWeeks`;
	CREATE TABLE IF NOT EXISTS `reunion_ParticipantWeeks` (
	  `ParticipantWeekID` int(11) NOT NULL auto_increment,
	  `ParticipantID` int(11) NOT NULL default '0',
	  `WeekID` int(11) NOT NULL default '0',
	  PRIMARY KEY  (`ParticipantWeekID`)
	) TYPE=MyISAM AUTO_INCREMENT=1
";
$db->query($sql);



// reunion_Participants
$sql = "
	DROP TABLE IF EXISTS `reunion_Participants`;
	CREATE TABLE IF NOT EXISTS `reunion_Participants` (
	  `ParticipantID` int(11) NOT NULL auto_increment,
	  `Name` varchar(50) NOT NULL default '',
	  `Priority` int(11) NOT NULL default '0',
	  `TimeStamp` datetime default NULL,
	  PRIMARY KEY  (`ParticipantID`)
	) TYPE=MyISAM AUTO_INCREMENT=1
";
$db->query($sql);



// reunion_Weeks
$sql = "
	DROP TABLE IF EXISTS `reunion_Weeks`;
	CREATE TABLE IF NOT EXISTS `reunion_Weeks` (
	  `WeekID` int(11) NOT NULL auto_increment,
	  `Date` varchar(100) NOT NULL default '',
	  `Event` varchar(100) default NULL,
	  `TimeStamp` datetime default NULL,
	  `DisplayOrder` int(11) default '0',
	  PRIMARY KEY  (`WeekID`)
	) TYPE=MyISAM AUTO_INCREMENT=1
";
$db->query($sql);

?>